package com.springboot.system.dao;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.springboot.system.domain.auth.Department;
import com.springboot.core.jdbc.BaseDao;

/**
 * 科室数据持久层实现类
 * 
 * @ClassName: DepartmentDao
 * @Description: TODO(这里用一句话描述这个类的作用)
 * @author 252956
 * @date 2021年1月7日 上午9:44:08
 *
 */
@Repository
public class DepartmentDao extends BaseDao {

	public List<Department> selectAll() {
		String sql = "SELECT id,name,  parent_id as parentId,levels,for_service as forService,sorts from t_sys_dept r where deleted=0  order by sorts asc ";
		return super.select(sql, Department.class);
	}

}
